-- created by kumiler
-- on 2023/3/11 16:44
-- DESC
CREATE external TABLE jms_ods.`sys_area_info_jt`
(
    `id`                bigint     ,
    `area_info_code`    string  COMMENT '片区编码',
    `network_code`      string  COMMENT '管辖区域编码',
    `network_name`      string  COMMENT '管辖区域名称',
    `next_network_code` string COMMENT '下级管辖区域编码',
    `next_network_name` string COMMENT '下级管辖区域名称'
) COMMENT '片区信息管辖区域表'
PARTITIONED BY (dt string COMMENT '更新/创建日期 (yyyy-MM-dd)')
stored as parquet
LOCATION '/dw/hive/jms_ods.db/external/sys_area_info_jt';

